<?php

require_once '../common/conn.php';

$db = new DBC();
$codes = "P1A001,P2A004,P3A001,P3C007,P4A021,P4A022";
$sql = "SELECT p.* FROM t_market_downloadtimes s LEFT JOIN t_product p ON s.code = p.flashcode AND p.flashcode NOT IN ('" . $codes . "') ORDER BY s.num";
$data = $db->fetchData($sql);

echo json_encode($data);
?>